中国网络(86SQL.COM)企业邮件系统

T-SQL Tutorial
Duration : 0:8:48

I’m trying to create a list of galleries in parent – child order so the results would come out like
Parent Gallery 1
Parent Gallery 1s children
Parent Gallery 1s children children
Parent Gallery 2
Parent Gallery 2s children
Parent Gallery 2s children children
and so on
Each gallery has an id and parentid, the top level gallery have parentid of 0. What [...]

TSQL example of how to identify non-printable characters and how to replace them in query output
Duration : 0:3:17

I’m trying to write a T-SQL script that involves cursors.
I’m getting errors. Is this code ok?
(all variables are varchar(20))
if @PhoneID=@PrevPhoneID and @PhoneType=@PrevPhoneType
Begin
Set @Phonetype=@Phonetype & "2")
[...]

T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error handling, row processing, and declared variables. Microsoft’s SQL Server and Sybase’s SQL server support T-SQL statements.
Short for Transaction-SQL, an extended form of SQL that adds declared [...]

T-SQL Tutorial
Duration : 0:9:37

declare @count int
declare @count1 int
set @count = 0
set @count1 = 2
while @count < 10
Begin
Set @Count = @count + 1
Print (@count) = (@count*@count1)
END
———————
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near ‘=’.
————-
I want this table to be printed like
2 x 1 = 2
2×10 = 20
ANY HELP PLEASE
Your mistake is that you’re assigning [...]

T-SQL TUTORIAL
Duration : 0:8:36

I’m having problems at work. We’re doing conversion from an old table schema to a new table schema, and we’re doing it in an ASP application (application service provider, not the microsoft technology with the same name). So we’re doing it for one facillity at at time. I need some [...]

hello every one,
I badly need someone help in learning TSQL ,please any one can help me with this, I am trying books but i cant understand few major thing (Variables,Functions) Or tell me any good place where i canlearn it.
Dear,
Sometimes abbreviated T-SQL, Transact-SQL is Microsoft’s and Sybase’s proprietary extension to the SQL language. Microsoft’s implementation [...]