Programming SQL

system view for functions
In sql server 2005 microsoft added system views to almost all the objects in system exept functions. is it true? ... 11 Jul 2010 05:05

Want to modify this procedure to have a range of periods rather than a single period
I have the procedure below I want simply modify the periods procedure below to be -- perpost >= '201001' and <= '201012' so I want a range of periods rather than a single period as in the example below I would really appreciate it if someone can help me out on this. Thanks Sammy USE DEMOAPP Declare ... 11 Jul 2010 08:17

Cursor problem
Hi there, I would like to get the rows count for all databases but from some reasion it bring me the rows of wich database I'm in How can I show the acual tables and rows count for each database? USE Northwind GO CREATE TABLE #tblRowsCount ( Database_name varchar(255), Table_name varchar(255), Row_Count ... 10 Jul 2010 14:56

How to find all tables and fields using max lengths in the database?
How do I find out (or list all tables and corresponding fields) that uses maximum/sql server default values whenever the objects are created in a particular database. For ex. If someone has created a user object with field name for ex. First Name with SQL Server default i.e. varchar(256) vs using varchar(50). H... 8 Jul 2010 21:28

Best way to store vectors?
Hi, Can anyone point me to a reference or discuss the best way to store a vector of 120 to 480 numbers in the database? Rows seem to be out since we would quickly top the billion row mark. A table with 480 columns is too unnormalized. A single varchar(max) column? This seems the best answer for now unless th... 9 Jul 2010 09:27

Whats the best method
Database1: CREATE TABLE [dbo].[tbl1] ( [sno] [int] IDENTITY(1,1) NOT NULL primary key, [strkeyValue] [varchar](max) NOT NULL, [dt] [datetime] NOT NULL ) GO sample: S:2221|TId:|dtstmp:2010/6/24 12:10:46|division:one|rate:10| Database2: CREATE TABLE [dbo].[tbldest]( [sid] [varchar](50) NULL, [T... 9 Jul 2010 23:50

setting text result set more then 8192
Hello there I am building system which take procedures from one place, displaying the script of store procedure and then i taking it and run it in a different server. But if the procedure script is more then 8192 it cutts it in the result. Is there a way not to cut it? ... 8 Jul 2010 17:00

using smart replace with replace
Hello there when u run replace(Field, 'abc', 'def') it replace any text in field who have 'abc' no metter what is before and after the text But if i want to replace 'abc[', 'abc', 'abc def', 'abc def', 'abc.def' ext.... and not replace 'abcd', 'abc_def' is there a way to do this? ... 8 Jul 2010 19:14

start using schema
Hello there I have database with over 200 tables, 50 views, 600 procedures, 150 funtions and 20 triggers. as a demen from my manager i need to transfer it to database with 10 schemas with some list of what is going to relate to some schema. To move objects to some schema is simple but to change it in all t... 8 Jul 2010 18:07

Select Inner.* from nested(outer)-nested(inner) query
Hi, Is it possible to "SELECT *" just the fields of a sub-nested query (i.e., I don't want * of a nested query, but of a nested-nested query)? For example (SELECT Inner.*): ---------------------------- SELECT Inner.* FROM ( SELECT Inner.* , ROW_NUMBER() OVER ( ORDER BY x ) AS R... 8 Jul 2010 18:07