You can specify it just after the column's name. Here is a small example:

create table test1 (id int, st varchar(30))

go

create table test2 (id int, st varchar(30) collate Latin1_General_CS_AS_KS_WS)

go

insert into...

Hope that I undestood what you need:

DECLARE @data table (n INT)

INSERT @data

SELECT 1 UNION ALL

SELECT 10 UNION ALL

SELECT 11 UNION ALL

SELECT 12 UNION ALL

SELECT 13 UNION ALL

SELECT 14 UNION...

Actually it means that your transaction log is not big enough and that it needs to grow more, but it can't because there is no disk space left (or it...

You can use the command DBCC shrinkfile (more details about it can be found in Books On Line), but the question is why? If during normal activity the log...

Case statement can only have one data type that it returns. Even if the case statement has few data types that it can return, it will return a data...

That depends. If you want to modify the string when you insert the data or when you update the data, you can use an "instead of trigger" to do...

You can use a simple replace function to do that:

declare @MyString varchar(30)

set @MyString = '/abc/def/ghij/kl'

select @MyString, REPLACE(@MyString,'/','//')

Adi

The fillfactor is kept when you build the index or reorganize it, but when you insert new data to the table, the fillfactor is ignored. Remember that the whole...

Under the default settings, each time that you do any compression with null, the results will false. You can checkout this code:

if 5 = null

select 'true'

else

select 'fales'

if 5 <>...

Here is one way of doing so:

declare @vc varchar(50)

declare @NewDate char(8)

--New date to replace

select @NewDate = convert(char(8),getdate(),112)

--Folder with date

set @vc = 'Myfolder/folder/dialy/20110531/sometext'

--Use the patindex fucntion in order to find the...

As far as I know, you’ll have to break the log shipping.

Adi

You are getting an error because you are forcing the server to do an implicit conversion of data type. The column’s data type is varchar(1). In the second...

Actually Lowell’s way is the correct one. Even if the union all query seems...

You can create a DDL trigger for login and check if the specific login is using SSMS (by checking the value of app_name() and original_login()). If he does, do...

If you have the same structure, but different length for each value, then you can convert it to XML and then use Xquery to get the data that you need....